USE [MobileManagerInfoV3]
GO

/****** Object:  StoredProcedure [dbo].[sp_CreateSIM]    Script Date: 02/15/2012 14:22:36 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO



-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>
-- Description:	<Description,,>
-- =============================================
CREATE PROCEDURE [dbo].[SP_CreateSIM] 
	@Imsi VARCHAR(50),
	@AreaNO VARCHAR(20),
	@ONO VARCHAR(2),
	@CNO VARCHAR(20),
	@ChannelNO VARCHAR(10)
AS
BEGIN
	INSERT INTO [T_SIM]
	(
		[IMSI]
		,[AreaNO]
		,[ONO]
		,[CNO]
		,[ChannelNO]
	)
	VALUES
	(
		@Imsi,
		@AreaNO,
		@ONO,
		@CNO,
		@ChannelNO
	)
END



GO


